1 Data preparation

Only data from 2016-07-01 onwards are included!

1.1 Exclusions

Raw dataset consists of 5,888,029 monthly stats of 346,581 properties.

First, 550 records of 33 properties located in remote areas (Christmas Island, Cocos (Keeling) Islands, Norfolk Island, Lord Howe Island) were excluded.

Second, 2,529,946 records of 266,638 inactive properties (sic!) were excluded.

10,341 records of 8,053 properties with missing info on max_guests had their max_guests racalculated to be 1*number of bedrooms.

For 622 records of 407 properties with missing info on max_guests that also had bedrooms info missing, max_guests was racalculated to be 1.

Final dataset of 3,357,533 monthly records of 324,872 properties was aggregated to SA3 levels.

Locations of Airbnb properties (points) were linked to ABS data of SA3 areas (polygons) from 2016. Spatial join in ArcGIS was used with CLOSEST option to capture locations that did not overlap with polygons (see example here https://www.airbnb.com/rooms/19103554 - due to privacy reasons, locations are not exact).

1.2 Areas with no data

Illawarra Catchment Reserve area, has no Airbnbs. Excluded from analyses!.

1.3 ‘Filling’ time series

Time series filled to inlcude 0s in areaXmonths aggregations with no observations.

2 Prepared dataset

2.1 2016+ monthly

2.1.1 GNO

2.1.2 GNA

2.1.3 GNO/GNA

2.1.4 Supply

2.2 2018 by state

2.2.1 Absolute

2.2.2 % of yearly GNO

2.3 2018 relation of utilization measures

2.4 2018 relation of supply measure

3 Areas of interest

3.1 Locations

3.2 Absolute

3.3 Relative

4 Monthly distribution of max GNO

4.1 Distributions

Calculating proportion of GNO from one region & one month treated as 1.

4.2 Jan

4.3 Aug

4.4 Jan vs Aug

4.5 Jan vs Aug

5 Session info

## R version 3.6.1 (2019-07-05)
## Platform: x86_64-w64-mingw32/x64 (64-bit)
## Running under: Windows 10 x64 (build 18362)
## 
## Matrix products: default
## 
## locale:
## [1] LC_COLLATE=English_Australia.1252  LC_CTYPE=English_Australia.1252   
## [3] LC_MONETARY=English_Australia.1252 LC_NUMERIC=C                      
## [5] LC_TIME=English_Australia.1252    
## 
## attached base packages:
## [1] stats     graphics  grDevices utils     datasets  methods   base     
## 
## other attached packages:
##  [1] googlesheets_0.3.0 naniar_0.4.2       kableExtra_1.1.0  
##  [4] sjmisc_2.8.2       summarytools_0.9.4 skimr_1.0.7       
##  [7] ggrepel_0.8.1      GGally_1.4.0       tmaptools_2.0-2   
## [10] tmap_2.3-1         sf_0.8-0           scales_1.0.0      
## [13] lubridate_1.7.4    janitor_1.2.0      readxl_1.3.1      
## [16] magrittr_1.5       forcats_0.4.0      stringr_1.4.0     
## [19] dplyr_0.8.3        purrr_0.3.3        readr_1.3.1       
## [22] tidyr_1.0.0        tibble_2.1.3       ggplot2_3.2.1     
## [25] tidyverse_1.2.1    pacman_0.5.1      
## 
## loaded via a namespace (and not attached):
##  [1] colorspace_1.4-1   pryr_0.1.4         ellipsis_0.3.0    
##  [4] class_7.3-15       visdat_0.5.3       leaflet_2.0.2     
##  [7] rgdal_1.4-7        sjlabelled_1.1.1   rprojroot_1.3-2   
## [10] dichromat_2.0-0    rstudioapi_0.10    xml2_1.2.2        
## [13] codetools_0.2-16   knitr_1.25         zeallot_0.1.0     
## [16] jsonlite_1.6       broom_0.5.2        rgeos_0.5-2       
## [19] shiny_1.4.0        compiler_3.6.1     httr_1.4.1        
## [22] backports_1.1.5    assertthat_0.2.1   fastmap_1.0.1     
## [25] lazyeval_0.2.2     cli_1.1.0          later_1.0.0       
## [28] htmltools_0.4.0    tools_3.6.1        gtable_0.3.0      
## [31] glue_1.3.1         reshape2_1.4.3     Rcpp_1.0.3        
## [34] cellranger_1.1.0   raster_3.0-7       vctrs_0.2.0       
## [37] nlme_3.1-140       leafsync_0.1.0     crosstalk_1.0.0   
## [40] insight_0.6.0      lwgeom_0.1-7       xfun_0.10         
## [43] rvest_0.3.5        mime_0.7           lifecycle_0.1.0   
## [46] XML_3.98-1.20      hms_0.5.2          promises_1.1.0    
## [49] RColorBrewer_1.1-2 yaml_2.2.0         pander_0.6.3      
## [52] reshape_0.8.8      stringi_1.4.3      e1071_1.7-2       
## [55] checkmate_1.9.4    rlang_0.4.1        pkgconfig_2.0.3   
## [58] bitops_1.0-6       matrixStats_0.55.0 evaluate_0.14     
## [61] lattice_0.20-38    rapportools_1.0    htmlwidgets_1.5.1 
## [64] labeling_0.3       tidyselect_0.2.5   plyr_1.8.4        
## [67] R6_2.4.0           magick_2.2         generics_0.0.2    
## [70] DBI_1.0.0          pillar_1.4.2       haven_2.2.0       
## [73] withr_2.1.2        units_0.6-5        RCurl_1.95-4.12   
## [76] sp_1.3-2           modelr_0.1.5       crayon_1.3.4      
## [79] KernSmooth_2.23-15 rmarkdown_1.16     grid_3.6.1        
## [82] digest_0.6.22      classInt_0.4-2     webshot_0.5.1     
## [85] xtable_1.8-4       httpuv_1.5.2       munsell_0.5.0     
## [88] viridisLite_0.3.0  tcltk_3.6.1